create index ix_tDDParams_1 on tDDParams([sprocid],[sprocrevid])